Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a Drill Dimension : TAB > CITY
and Expression :Count({<Category= {'home_screen'},Action={'Scroll_to_tab'}>} VID)
And i have one more Field CardTypeSub . i want if user select CardTypeSub value nothing will change.
means it ignore the selection for CardTypeSub .
i tried ,
Count({<Category= {'home_screen'},Action={'Scroll_to_tab'},CardTypeSub=>} VID)
... But with this expression ... it drill the value automatically in city level..
i want if user select CardTypeSub ... nothing will get change..
Kindly help me on this..
small chnge
=sum({1<CardTypesub={'values'}>} CardType)
Try like this
if (getselectedcount(CardTypeSub)>0 and getselectedcount(CITY)=0, Count({<Category= {'home_screen'},Action={'Scroll_to_tab'},CardTypeSub=,CITY=>} VID),Count({<Category= {'home_screen'},Action={'Scroll_to_tab'},CardTypeSub=>} VID))
Hi,
better to have two dimensions one with Drill down and other with the first dimension of that drill down, and use condition
"Enable condition" for one of the dimension based on the selection of the field which you want to ignore selections.
Hope I am clear
Thanks
Kiran Kumar
You can make Listbox of CardTypeSub as Read Only.
List Box Properties ---> General Tab ---> check Read Only.
Hi Brijesh,
Did you try this?
Count({<CardTypeSub,Category= {'home_screen'},Action={'Scroll_to_tab'}>} VID)
Cheers,
Naresh
Hi Naresh ,
No its not working this...Can u please download my qvw file and try to do it on it..
the thing is that same App i need to create in Qliksense as Well... and their as well i am getting an same error
is this?
Yup.. This QVW
There are more options ...
1.) Create Alternate State for Listbox CardTypeSub
2.) General Tab of Chart
GetSelectedCount(CardTypeSub)=0
if user select any value from listbox of CardTypeSub.... Chart will show
Calculation Condition Unfullfilled
You can Change this Error like
Please clear CardTypeSub or as you want
May be like attached