topic Re: Conditional display based on Variable in QlikView

Conditional display based on Variable

Wed, 15 Apr 2015 09:54:45 GMT

Hallo,

I just downloaded QV and watched some videos how to use it on Youtube.

Now I am trying to design my first report and i got some issues.

I successfully loaded Data from a SQL Server. There is a value called "Rating". It ranges from 1.00 to 99.99.

Now I created a Textfield with a variable "UserEntryRating".

So when the user enters a value (e.g. 95.50) the rest of my Report should only show Data where "Rating" ins greater than the value "UserEntryRating"(e.g. 95.50).

Is this possible? Or do i have to configure this per item on my Dashboard?

I first thought of another variable "visible", which decides if this entry should be shown or not.

Or is there another way to do this?

Thanks for your time.

Ps.: I only got Personal Edition to test it. It would be nice if you could descripe how you would do it.

Re: Conditional display based on Variable

terezagr — Wed, 15 Apr 2015 11:00:19 GMT

Hi,

I have created an Inline table with possible data:

Then create the following variable vRating
Create and input box with displayed variable vRating
Create a chart->Straight table where dimension will be field
In your straight table use the following expression:

if($(vRating)>=95,

if(Rating>=95,Rating, 'Not in Range'),'')

And it all looks like this:

Re: Conditional display based on Variable

Wed, 15 Apr 2015 11:55:38 GMT

Hello,

thanks TerezaGr for your fast answer and the really nice Screenshots.

I still got a few Questions:

1. What does the $ sign do? Is it like in Excel to set a permanent value?

2. Why is it

if($(vRating)>=95,

if(Rating>=95,Rating, 'Not in Range'),'')? The 95.50 was just an example if this refers to my post.

Isn't there anything like

if(vRating < Current Row Rating, Current Row Rating, ignore this row)

Italic means unknown function in QlikView.

Thanks again for your help.

Re: Conditional display based on Variable

vikasmahajan — Wed, 15 Apr 2015 12:05:49 GMT

PFA document

Vikas

Re: Conditional display based on Variable

Wed, 15 Apr 2015 14:26:04 GMT

As I wrote, its not possible to open a document that wasn't created by me in personal edition.

Could you please descripte what is done in that document and how this solves my problem?

Thank's for your help.

Re: Conditional display based on Variable

vikasmahajan — Thu, 16 Apr 2015 03:33:33 GMT

Please attach your document to help

Vikas

Re: Conditional display based on Variable

Thu, 16 Apr 2015 05:38:13 GMT

I've made a showcase cause of sensible Data.

So here we got a table with 3 values.

On the GUI, is a Textbox and a Diagram.

Based on the number in the Textbox, the Diagram should only show values where minRating<Rating.

In this case it should only show "D" with the count 3.

Re: Conditional display based on Variable

Thu, 16 Apr 2015 09:52:09 GMT

I tried to modify my count. But now it sais, that there are no data available.

I tried to create a conditional count like hereCount If ‌but this doesn't work.

The count now looks like this:

count({<Rating={">= $(minRating)"}>} Another_Field)

It would be really great if someone could help me.