Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
marjan_it
Contributor III

how to show dimension that have only 2 special value in qlikview

hi All

i have a table like the image. how to show the file_no that usage type is just only is 0101 and 1201 not anything more or less. in this sample we want to show just file_no (10000608,10000616)

is there any function in qlik view that show ONLY this 2 file_no?!!!!Untitled.png

Tags (3)
5 Replies
marjan_it
Contributor III

Re: how to show dimension that have only 2 special value in qlikview

Hi I do like the sample. in this sample file_no is correct. in fact show the correct file_no.but in usage_type_code doesnt show the both of them 0101 and 1201 and for each file-no just show one of the usageTypecode number.

why show like this?

marjan_it
Contributor III

Re: how to show dimension that have only 2 special value in qlikview

Any ideas?

narayanamsn
Contributor

Re: how to show dimension that have only 2 special value in qlikview

Hi,

Store the file onto QVD and create a separate QVW for the report.. while calling the QVD to fetch the data in new QVD use match function in the script..so that you can restrict the values that are visible ...

Regards,

Satya

qlikview979
Valued Contributor

Re: how to show dimension that have only 2 special value in qlikview

Hi Try This, first in text box.

If you want count of that two numbers.

=Count({<usage_type_code={0101,1201}>}file_no)

or

=Count({<file_no={10000608,10000616}>}usage_type_code)

Regards,

Mahesh.

marjan_it
Contributor III

Re: how to show dimension that have only 2 special value in qlikview

no it doesnt work at all. in my sample I could  proper find file_no but it doesent show both usage type code 0101 and 1201. for eaech file_no just show one of them in chart.