topic How to create conditional dimension in QlikView

How to create conditional dimension

Thu, 25 Jul 2013 06:55:38 GMT

Hi ,

I need to create a table box in Qlikview having two columns City ,Sales. The requirement is that only those City should be displayed where sales=0.

Ex: City Sales

NY 0

NJ 0

BO 0

Please suggest any solutions

Re: How to create conditional dimension

tresB — Thu, 25 Jul 2013 07:09:03 GMT

instead of table box, try with straigth table. take the first dimension as calculated dimension and write the expression like: if(Sales=0, City) ....... calculated dimension

and for expression : =Sales ........expression tab..... assuming that your data is already aggregated.

Re: How to create conditional dimension

alexandros17 — Thu, 25 Jul 2013 07:09:08 GMT

Add the following expression

if(sum(sales)=0,'Zero',0)

and check the box "Exclude 0 values" in this way you set a value for o sales and set 0 to cities with sales (and exclude them)

Hope it helps

Re: How to create conditional dimension

nirav_bhimani — Thu, 25 Jul 2013 07:35:58 GMT

Try this in script,

Cities:

Load * Inline [

City,Sales

NY,0

NJ,0

BO,0

CO,1

];

CITY_MAP:

Load City , Sum(Sales) , If (Sum(Sales)=0, City ) as CityFlag

resident Cities

group by City;

Now use CityFlag & Sales in the dimension of table box.

In the presentation select Omit row to null check box.

Regards,

Nirav Bhimani