topic Re: Allow only one dimension to select in QlikView

Allow only one dimension to select

sunil1989 — Fri, 21 Apr 2017 05:05:01 GMT

Hi ,

Thanks in advance!!!!

I am having straigh table on my sheet and the column are

Dimension : Delivery date , location.

Expression :Total Orders,WOW Orders , Average Basket.

whenever any date selected on delivery date it should ignore the selected date , but it should select the location , the location which is selected.

Thanks,

Sunilkumar

Anil_Babu_Samineni — Fri, 21 Apr 2017 05:15:30 GMT

May be ignore the selections like

Sum({<[Delivery Date]>} [Total Orders]) //Same for all expression may be

sunil1989 — Fri, 21 Apr 2017 05:32:28 GMT

Hi Anil ,

Apology for dual post.

but my dimension has calculated dimension i.e Delivery Date(WEEKDAY(DeliveryDate) &' ' & Date(DeliveryDate,'DD-MM-YYYY')).

avinashelite — Fri, 21 Apr 2017 05:36:14 GMT

Since the calculated dimension is based on the delivery Date the above logic should work

include {<[Delivery Date]>} set analysis in all the expression