Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

mhapanka
New Contributor III

Showing a graph as blank until a filter is applied

I have a graph in which I have Region as Dimension & Sales as measure. I want to show this graph as blank unless one filter on LRM-MVS-Relo is applied.

In the add-on section, data handling, I used the formula:

count(distinct([LRM-MVS-Relo])=1)

and have displayed the message in it saying select one from LRM,MVS or relo.

However this is not showing blank. Can someone correct me if my logic is wrong ?

1 Solution

Accepted Solutions
arvind1494
Valued Contributor

Re: Showing a graph as blank until a filter is applied

If you want to show that graph at only one selection then use this:

GetSelectedCount([LRM-MVS-Relo])=1




And

If you want to show that graph on  selection in that field then use this:

GetSelectedCount([LRM-MVS-Relo])>0

10 Replies
MVP
MVP

Re: Showing a graph as blank until a filter is applied

Just change it slightly into this:

Count( DISTINCT [LRM-MVS-Relo] ) = 1



dhanaji_roman
New Contributor II

Re: Showing a graph as blank until a filter is applied

Hi,

Try this

if(GetSelectedCount([LRM-MVS-Relo])=1 ,1,0)

Thanks & Regards,

Dhanaji Roman

rangam_s
Contributor II

Re: Showing a graph as blank until a filter is applied

Try this.

GetSelectedCount([LRM-MVS-Relo])=1


shraddha_g
Honored Contributor III

Re: Showing a graph as blank until a filter is applied

Try,

If(getselectedcount([LRM-MVS-Relo]) = 1,1,0)

arvind1494
Valued Contributor

Re: Showing a graph as blank until a filter is applied

If you want to show that graph at only one selection then use this:

GetSelectedCount([LRM-MVS-Relo])=1




And

If you want to show that graph on  selection in that field then use this:

GetSelectedCount([LRM-MVS-Relo])>0

mhapanka
New Contributor III

Re: Showing a graph as blank until a filter is applied

Thanks so much!

I also want the part after "for" in the title to change according to what is selected. I have written something like:

='Sales and Discount by Region for' & if Count( DISTINCT [LRM-MVS-Relo] ) = 1 Concat count(distinct[LRM-MVS-Relo]

How can this be corrected to show me the Selected item/items after "for" in the title

arvind1494
Valued Contributor

Re: Showing a graph as blank until a filter is applied

Try this :

='Sales and Discount by Region for'&GetFieldSelections([LRM-MVS-Relo])

arvind1494
Valued Contributor

Re: Showing a graph as blank until a filter is applied

='Sales and Discount by Region for    '&GetFieldSelections([LRM-MVS-Relo])

mhapanka
New Contributor III

Re: Showing a graph as blank until a filter is applied

This works, Thanks a ton!

Community Browser