Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
sunil1989
Contributor
Contributor

Allow selection only on one dimension

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

2 Replies
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

You can ignore the selection using the set analysis, something like below.

Sum({<Delivery_Date=>}TotalOrders)

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
Anil_Babu_Samineni

Don't create double posts for single issue

Allow only one dimension to select

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful