topic Re: Variable Storing Dimention not working as expected in App Development

Variable Storing Dimention not working as expected

prashantsanchet — Mon, 05 Mar 2018 12:39:08 GMT

Hi team,

I have a one requirement where

i will have a dropdown selctor like (Dynamic Dimention Name) like Customer, Region, Country

The selected value will be stored into variable vDropdownSelector:

I will have a bar chart where based on selection in drop down my dimension value will be change

and i have measure as sum(sales) .

1) What is the best way to implement this in qliksense.

2) I have other requirement where i need to show the same bar chart but only that row if ( sum(margin) >=0)

I tried this but its not working as expected

vDashboardSelector :

if (vDropdownSelector,'Customer', [Customer] ,

if (vDropdownSelector,'Region', [Region],if (vDropdownSelector,'Country',[Country])))

Dimention: $(vDashboardSelecto)

Measure:

Sum({<"=(vDashboardSelector)" ={"=Sum([margin])>=0"} >}sales)

Please provide your valuable comments

Re: Variable Storing Dimention not working as expected

jwjackso — Mon, 05 Mar 2018 13:12:25 GMT

I tried this in Qlik Sense:

Set vSelected='=GetFieldSelections(Dim)';

DData:

LOAD * Inline [

Dept,Amt

101,100

101,200

102,200

102,400

];

PData:

Load * Inline [

Prod,Amt

Computer,400

Phone,300

];

DList:

LOAD * Inline [

Dim

Dept

Prod

];

Re: Variable Storing Dimention not working as expected

prashantsanchet — Mon, 05 Mar 2018 14:10:15 GMT

Hi ,

Thanks fro your reply. I have condition i measure like if Sum([margin])>=0" then only show t

This is not working as expected as i am having following measure

Dimention: $(vDashboardSelecto)

Measure:

Sum({<"=(vDashboardSelector)" ={"=Sum([margin])>=0"} >}sales)

Please provide your valuable comments

Re: Variable Storing Dimention not working as expected

jwjackso — Mon, 05 Mar 2018 14:53:27 GMT

The dimension should already be specified, can you use an "If" statement.

=If(Sum([margin]) >= 0,Sum(sales),0)

Then suppress zeroes.