topic Re: Dyanmic Filter in QlikView

Dyanmic Filter

Akshay2015 — Fri, 04 Oct 2019 09:08:54 GMT

Requirement: I want to show the text "TOTAL SALES" if no filter selected & if any filter selected show the dynamic text as Image1 ie (Sales for 2014 $123) , Is there any workaround to embed the two dynamic text in one text object, if we are not selecting any filter the text won't change as per the requirement (Image 2 )

Example

1)If no filter is selected show "TOTAL SALES $123"

2)If 2014 selected show "Sales for 2014 $123"

Kindly share your inputs.

Re: Dyanmic Filter

Brett_Bleess — Thu, 10 Oct 2019 18:46:07 GMT

Akshay, I think the best way to go at this one is two objects that are set to sit in the same space and use conditional show condition to show the one you want based upon whether or not there is a selection in your field... Actually found a design blog post that may help here:

https://community.qlik.com/t5/Qlik-Design-Blog/Enhancing-the-User-Experience-Using-Conditional-Expressions/ba-p/1472583

Regards,
Brett

Re: Dyanmic Filter

sunny_talwar — Thu, 10 Oct 2019 19:03:02 GMT

May be using an If statement?

If(GetSelectedCount(Year) = 0, 'TOTAL SALES ', 'Sales for ' & Year) & Money(Sum(Sales))

Re: Dyanmic Filter

JGMDataAnalysis — Fri, 11 Oct 2019 03:26:39 GMT

This option contemplates the possibility of selecting more than one value in the Year field.

Note: if the format applied by the Num function is not displayed properly, change the period with a comma.

If(GetSelectedCount([Year]) = 0 Or GetSelectedCount([Year]) = Count({1} distinct [Year]), 'TOTAL SALES ', 'Sales for ' & Concat(distinct [Year], ', ')) & Chr(10) & Num(Sum([Sales]), '$ #.##0')