I want to replace 'if condition' in a set expression with an alternative expression giving the same result. But my data markers are getting vanished after that. How to resolve it? Below is the set expression for which i need an alternate expression without if condition but with the same results.

=
If(
Sum({<location={ 'ALL'}, metric={'free'},frequency_value-={'FY’},
type={'real '}, source_file_name={'$(v_filename) '}
>}sales)
>0,
Sum({<location={ 'ALL'}, metric={'free'},frequency_value-={'FY’},
type={'real '}, source_file_name={'$(v_filename) '}
>}sales)

Has anyone using/used Qlik sense dashboards to analyse ecommerce traffic data?

We are getting huge volume of data from snowplow, but thinking whether qlik sense is the right tool for this.

I would like to hear from someone had actually done this in qlik successfully.

Thanks.

These are the queries we are trying to tackle with user friendly dashboards.

Identifying customers landing on out of stock products

• How many customers are landing on oos products?
• Which products are they?
• Which brands are they?
• What traffic source?
• What do the customers do?
• Bounce
• CVR
• Funnel analysis – where do customers go next?

Looking at customer journeys by landing page brand

• How many customers are landing on a brand?
• How many of the landing products are OOS?
• What do the customers do?
• Bounce
• Conversion Rate
• Add to bag
• Funnel analysis – where do they go next?

Looking at funnel analysis

• How many customers are landing on the site on the different page types (PDP/Home page etc.)
• What are the common customer journeys (i.e. PDP > PDP > PDP, HomePage > Cat Page)
• Which journey types are highest converting

Looking at marketing traffic

• Looking at the percentage make up of traffic across the traffic types by time to understand growth of channels
• Looking at change in CVR by channel across time
• Look at landing page by channel
• How many OOS views?
• What are the brands

Hi, I wonder, why my expression not working.
Its good only with no selections:

When I chose date its 0, I would like it to show the sum result for the current date minus 2 days

My expresion:

Sum({<Data={"$(= date((Max(Data)-2)))"}>} stan_wartosc)

My code in Data Load Editor look like this:

NoConcatenate
Stan_Wartosc_2:
Load
    date(floor(Data)) as Data,
	hid_dossier_ges, 
	hid_artykul_ges,
    sum(stan_wartosc) as stan_wartosc
Resident Stan_Wartosc
Group By
	Data,
	hid_dossier_ges, 
	hid_artykul_ges
    ;
    
Drop Table Stan_Wartosc;

Hi guys, is it possible to automate the remove of an Analytics License from a user Professional? With a security rule? I would like to make sure everyone has only one license. Thank you.

Hi Qlik Teams,

Is anyone using same license key for PROD and DR servers? Currently, we are using Qlik Sense Enterprise - Client Managed. We are trying to install the Qlik Sense on the DR of the client but we only have PROD License key. Can we use it for DR? 

Thank you.

Hi ,

Could someone help me rectify the error in following script(Attached screenshot).

Getting error 'ValueCategoryGlobal' and 'ProcessTypeGlobal' not found. Though these fields are present in residents tables Valuecategory and ProcessType respectively.

I am expecting Fields Value, ValueCategoryGlobal and ProcessTypeGlobal in temp table. But only field coming is Value.

Hi,

Can you kindly help me understand how to apply distinct count for the following expressions,

count(distinct{<[Price check]={"=If((sum([Dealer Sell-in price])-[Unit Price (EUR)])>0,'N','Y')"}>}[Part Number])

In the above expression,  , Unit Price = sum(Price * Exchange
)/sum(Quantity), Price check=If((sum([Dealer Sell-in price])-([Unit Price (EUR)]))>0,'N','Y'))

Currently, the formula is making distinct count on all the part number but I need it distinct count only the [Part Number] with [Price check] is 'Y' for each Dealer.

Let me know if you need any other details from me.

Thanks in advance

I need to modify an existing P&L table with several scenarios (using the Vizlib solution with external Excel table).

Is it possible in a P&L table to use different factors per line?

sum(  Value* $(=PL_View_Factor_Best) )

I get the right calculation, when the factor is the same for all lines, but when using different values or even a conditional value for different scenarios, it returns no value.

Is there another/better way to solve this?