Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

kunkumnaveen
Contributor III

how to select values

Hello All,

A kind of wired thing is going on with my dashboard,the thing is ,the thing  which was working great before reload was not working  ,anymore after reload

LSCREE.png

this is how my dashboard look,3 charts

Dimension:1) LOCATION,

                 2)LocationQuality

expression:

firstsortedvalue(distinct {<Category=,Decision=,ROLE=,SUPCAT=,YEAR=,LOCATION=,name1=,ENSTEHDAT=,MaterialName= ,LocationQuality={QUALITY_GOV }  >} Value, -ADATE)

so on click on any of these three chart ,it used to get select both dimension values,i mean this

SCR2.pngSCR3.png

After going a reload i got new LOCATION data in to dashboard ...

SCR4.png

so on click on any of these three charts, only LOCATION is getting selected but not LocationQuality any more,even though i have same

dimensions and expression

scr5.png

it working fine if i promote and demote dimension i mean

Dimension:1)LocationQuality

                 2) LOCATION

scr6.pngscrrr8.png

but i want it to work when dimensions are:

                                      1)LOCATION

                                       2)LocationQuality

PFA....

plz any suggestion ..thanks

Community Browser