topic Re: unable to set static expression in qlikview . in QlikView

unable to set static expression in qlikview .

arunqlik2view — Wed, 25 Nov 2020 16:16:04 GMT

Hello All,

Count({1<[SEGMENT] = {'*'}>} {[Alternate_State1]*$}DISTINCT[Partnumber])

the above expression works fine when no selection is made , but when I made select to the listbox of SEGMENT, then it points to that particular SEGMENT selection which I don't want . I followed the post at Creating a static Chart | Qlik Community but no luck .

please advice

thanks ,

Arun

Re: unable to set static expression in qlikview .

PrashantSangle — Mon, 03 Sep 2018 04:49:20 GMT

Hi,

If you want that your chart won't changed on any changes then simply nullify those field from your set analysis.

or simply right click on chart > select Detach

Regards,

Re: unable to set static expression in qlikview .

dx_anupam — Mon, 03 Sep 2018 05:44:59 GMT

Hi Arun,

I am not sure why you are using multiple statements in Set analysis.

Count ({1} [Partnumber]) will sort out your issue if you don't want any selection affect on your chart.

Regards,

Anupam

Re: unable to set static expression in qlikview .

pooja_prabhu_n — Mon, 03 Sep 2018 11:46:04 GMT

Hi,

Try this

=Count({[Alternate_State1]<[SEGMENT] =$::[SEGMENT]>} DISTINCT [Partnumber])

Thanks,

Pooja

Re: unable to set static expression in qlikview .

arunqlik2view — Tue, 04 Sep 2018 06:47:13 GMT

Hi Anupam, thanks for the reply

When I try the below suntax as per your advice, it does the same thing.

where ,

Alternate_State1 = Distributor1 , locked in a list box.

= Count ({1} {[Alternate_State1]*$} DISTINCT [Partnumber])

. Basically , I want to get total distinct count all Part Numbers of all segments for distributor1. If I choose any Segment , it should not show total distinct count of part numbers for that particular segment. Currently above syntax total Distinct Count of all Partnumbers for segment but for all Distributors too. Need to filter it one distributor only .

Thanks in Advance,

Arun

Re: unable to set static expression in qlikview .

arunqlik2view — Tue, 04 Sep 2018 07:01:46 GMT

Hi Pooja, Thanks for the reply , I tried your syntax, the values are off by 100's .

Count({[Alternate_State1]<[SEGMENT] =$::[SEGMENT]>} DISTINCT [Partnumber])	Correct Distinct Count of Partnumbers
919	734
853	605
756	591
726	583
706	460
596	446
566	398
529	399
519	400
501	389
482	361
475	346
454	283
401	296