Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
Could you please anybody help me to flip values in
Pivot table with number/images based on list box value.
I.e.if I select number item from list box values should show as numbers in pivot table else if I select image option the values in pivot table should display with
Right mark/Cross mark/exlimenater mark.
Hi,
Can you attach the sample Qvw file?
I want to see what values/images you have in List box?
Thanks,
Mukram.
In Qlikview, we have default icons like Images which covers Icons / Arrows / Smileys etc. So, you can get it those as per needs. But, Question not clear what you did and needed
Please find data below
Pivot dimensions are class->student name->subject name.
Assume 3 subjects in each class and subject column will hold marks secured in that subject, pass>36 ,fail <36 Or student absent(exlimenate symbol)
If X class student attended any subject exam if passed
>36 than show right check symbol/secured marks ,if fail<36 than show X symbol/secured marks ,if not attended show null value/exlimenation markin each subject column
Hence need a flexibility to view data in table either with numbers of each subject or the images associated to each subject by using another list box buttons {numbers,symbol}
If select numbers button data show in table with numbers or if select symbol the data should in pictorial representatinon
.I. E. Right mark/Cross mark/exlimenation mark